[dbo].[PhysicalAddress]

Property	Value
Created	10:31:32 AM Tuesday, March 02, 2010
Last Modified	11:40:05 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)
AddressKey	uniqueidentifier	16
Address1	nvarchar(50)	100
Address2	nvarchar(50)	100
Address3	nvarchar(50)	100
City	nvarchar(50)	100
StateProvinceCode	nvarchar(5)	10
Region	nvarchar(50)	100
PostalCode	nvarchar(20)	40
CountryCode	nchar(2)	4
County	nvarchar(50)	100
MailCode	nvarchar(5)	10
TimeZoneKey	uniqueidentifier	16
CarrierRoute	nvarchar(10)	20
DeliveryPointBarCode	numeric(12,0)	9
LineOfTravel	nvarchar(5)	10
BarCode	nvarchar(14)	28
USCongress	nvarchar(5)	10
StateSenate	nvarchar(5)	10
StateHouse	nvarchar(5)	10
Latitude	decimal(8,2)	5
Longitude	decimal(8,2)	5
TaxScheduleKey	uniqueidentifier	16

	Name	Columns	Unique
	PK_PhysicalAddress	AddressKey
	IX_PhysicalAddress_City	City
	IX_PhysicalAddress_CountryCode	CountryCode
	IX_PhysicalAddress_PostalCode	PostalCode
	IX_PhysicalAddress_StateProvinceCode	StateProvinceCode

Name	Columns
FK_PhysicalAddress_AddressMain	AddressKey->[dbo].[AddressMain].[AddressKey]
FK_PhysicalAddress_CountryRef	CountryCode->[dbo].[CountryRef].[CountryCode]
FK_PhysicalAddress_MailCodeRef	MailCode->[dbo].[MailCodeRef].[MailCode]
FK_PhysicalAddress_TimeZoneRef	TimeZoneKey->[dbo].[TimeZoneRef].[TimeZoneKey]

SQL Script

CREATE TABLE [dbo].[PhysicalAddress]
(
[AddressKey] [uniqueidentifier] NOT NULL,
[Address1] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address3] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StateProvinceCode] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Region] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PostalCode] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CountryCode] [nchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[County] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailCode] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TimeZoneKey] [uniqueidentifier] NULL,
[CarrierRoute] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeliveryPointBarCode] [numeric] (12, 0) NULL,
[LineOfTravel] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BarCode] [nvarchar] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USCongress] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StateSenate] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StateHouse] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Latitude] [decimal] (8, 2) NULL,
[Longitude] [decimal] (8, 2) NULL,
[TaxScheduleKey] [uniqueidentifier] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[PhysicalAddress] ADD CONSTRAINT [PK_PhysicalAddress] PRIMARY KEY CLUSTERED ([AddressKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PhysicalAddress_City] ON [dbo].[PhysicalAddress] ([City]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PhysicalAddress_CountryCode] ON [dbo].[PhysicalAddress] ([CountryCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PhysicalAddress_PostalCode] ON [dbo].[PhysicalAddress] ([PostalCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PhysicalAddress_StateProvinceCode] ON [dbo].[PhysicalAddress] ([StateProvinceCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PhysicalAddress] ADD CONSTRAINT [FK_PhysicalAddress_AddressMain] FOREIGN KEY ([AddressKey]) REFERENCES [dbo].[AddressMain] ([AddressKey])
GO
ALTER TABLE [dbo].[PhysicalAddress] ADD CONSTRAINT [FK_PhysicalAddress_CountryRef] FOREIGN KEY ([CountryCode]) REFERENCES [dbo].[CountryRef] ([CountryCode])
GO
ALTER TABLE [dbo].[PhysicalAddress] ADD CONSTRAINT [FK_PhysicalAddress_MailCodeRef] FOREIGN KEY ([MailCode]) REFERENCES [dbo].[MailCodeRef] ([MailCode])
GO
ALTER TABLE [dbo].[PhysicalAddress] ADD CONSTRAINT [FK_PhysicalAddress_TimeZoneRef] FOREIGN KEY ([TimeZoneKey]) REFERENCES [dbo].[TimeZoneRef] ([TimeZoneKey])
GO